Using Keyset-Driven Scrollable Cursors

The ODBC driver does not support using keyset-driven cursors on stored procedures or explicit batches.
The ODBC driver cannot use keyset-driven cursors, when the Select statement contains any of the following SQL language constructions:
JOIN
Aggregate functions
GROUP BY
(Informix only). When a fragmented table is not explicitly created with the WITH ROWIDS clause, the ODBC driver returns SQL_SUCCESS_WITH_INFO, with the message that a static cursor was substituted.